PendingApplicant

EntityType | Independent
Logical Entity Name | PendingApplicant
Default Table Name | AmOnlineApplicant
Logical Only | NO
Owner | dbo
Definition |
Note |

PendingApplicant Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
WpUserID |  | INTEGER | NO |
WebUserName |  | CHAR(128) | NO |
LastName |  | VARCHAR(25) | NO |
FirstName |  | VARCHAR(25) | NO |
MiddleName |  | VARCHAR(100) | YES |
SSN |  | CHAR(16) | YES |
StreetAddress |  | VARCHAR(255) | NO |
City |  | CHAR(25) | NO |
State |  | CHAR(2) | NO |
PostalCode |  | CHAR(10) | NO |
CountryId |  | INTEGER | NO |
PhoneNumber |  | CHAR(16) | NO |
WorkPhoneNumber |  | CHAR(16) | YES |
WorkPhoneNumberExtension |  | VARCHAR(10) | NO |
OtherPhoneNumber |  | CHAR(16) | NO |
EmailAddress |  | VARCHAR(50) | NO |
OtherEmailAddress |  | VARCHAR(50) | YES |
PermanentStreetAddress |  | VARCHAR(255) | YES |
PermanentCity |  | CHAR(25) | YES |
PermanentState |  | CHAR(2) | YES |
PermanentPostalCode |  | CHAR(10) | YES |
PermanentCountryId |  | INTEGER | YES |
PermanentPhoneNumber |  | CHAR(16) | YES |
LeadSourceId |  | INTEGER | YES |
AssignedAdmissionsRepId |  | INTEGER | YES |
ApplicantTypeId |  | INTEGER | YES |
CitizenID |  | INTEGER | YES |
AlienNumber |  | CHAR(9) | YES |
DriverLicenseNumber |  | CHAR(20) | YES |
DriverLicenseState |  | CHAR(2) | YES |
MaritalStatusId |  | INTEGER | YES |
DateOfBirth |  | DATETIME | YES |
GenderId |  | INTEGER | YES |
EthnicityId |  | INTEGER | YES |
CampusID |  | INTEGER | YES |
DegreeID |  | INTEGER | YES |
ProgramID |  | INTEGER | YES |
ProgramVersionID |  | INTEGER | YES |
StartDate |  | DATETIME | YES |
StartDateID |  | INTEGER | YES |
HighSchoolID |  | INTEGER | YES |
HighSchoolGraduationDate |  | DATETIME | YES |
IsGraduatedFromHighSchool |  | TINYINT | YES |
HighSchoolGPA |  | NUMERIC(11, 6) | YES |
PersonalStatement |  | TEXT | YES |
CreditCardTypeId |  | INTEGER | YES |
CreditCardNumber |  | VARCHAR(500) | YES |
LastFourCreditCardNumber |  | CHAR(4) | YES |
CreditCardExpirationDate |  | DATETIME | YES |
CreditCardHolderName |  | VARCHAR(50) | YES |
CreditCardHolderStreetAddress |  | VARCHAR(50) | YES |
CreditCardHolderPostalCode |  | VARCHAR(15) | YES |
CreditCardHolderCity |  | VARCHAR(30) | YES |
CreditCardHolderState |  | CHAR(2) | YES |
PaymentAmount |  | MONEY(19, 4) | YES |
IsActive |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
HighSchoolGraduationYear |  | VARCHAR(4) | YES |
PreviousEducationId |  | INTEGER | YES |
LeadTypeId |  | INTEGER | YES |
NewProspectSchoolStatusId |  | INTEGER | YES |
FinalSchoolStatusId |  | INTEGER | YES |
PendingApplicantId |  | INTEGER | NO |
TitleId |  | INTEGER | YES |
ApplicantProgress |  | INTEGER | NO |
AreaOfStudyList |  | NTEXT/LONG NVARCHAR | NO |
IsDuplicate |  | BIT | NO |
IsNewLeadApplicant |  | BIT | NO |
StudentId |  | INTEGER | YES |
CreditCardHolderFirstName |  | VARCHAR(50) | NO |
CreditCardHolderLastName |  | VARCHAR(50) | NO |
MobilePhoneNumber |  | CHAR(16) | YES |
SmsServiceProviderId |  | INTEGER | YES |
IsSubscribedToSms |  | BIT | NO |
GradeLevelId |  | INTEGER | YES |
GEDAwardedDate |  | DATETIME | YES |
HispanicLatino |  | CHAR(1) | YES |
CreditCardAuthorizationNumber |  | CHAR(10) | YES |
CoRelationIdentifier |  | NVARCHAR(20) | YES |
CampusId |  | INTEGER | YES |
SchoolStartDateId |  | INTEGER | YES |
Id |  | INTEGER | YES |
AdmissionsRepId |  | INTEGER | YES |

PendingApplicant Keys

Key Name | Key Type | Keys
AmOnlineApplicant_CMSMSServiceProviderID_N_N_IDX | Inversion Entry | SmsServiceProviderId
AmOnlineApplicant_AmTitleID_N_N_IDX | Inversion Entry | TitleId
PK_AmOnlineApplicant_AmOnlineApplicantID | PrimaryKey | PendingApplicantId
AmOnlineApplicant_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId

PendingApplicant Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
ApplicantType | Non-Identifying | Zero or One to Zero or More |  |  |  | ApplicantTypeId | NO
AdmissionsRep | Non-Identifying | Zero or One to Zero or More |  |  |  | AdmissionsRepId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO
Title | Non-Identifying | Zero or One to Zero or More |  |  |  | TitleId | NO
SmsServiceProvider | Non-Identifying | Zero or One to Zero or More |  |  |  | SmsServiceProviderId | NO
LeadSource | Non-Identifying | Zero or One to Zero or More |  |  |  | LeadSourceId | NO
SchoolStartDate | Non-Identifying | Zero or One to Zero or More |  |  |  | SchoolStartDateId, Id | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
PendingApplicantEthnicity | Non-Identifying | One To Zero or More |  |  |  |  | NO
PendingApplicantSchoolStatusHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
AmOnlineApplicantSyPersonGenderPronoun | Non-Identifying | One To Zero or More |  |  |  |  | NO
PendingApplicantSchoolDefinedFieldValue | Non-Identifying | One To Zero or More |  |  |  |  | NO
PendingApplicantEthnicity | Non-Identifying | One To Zero or More |  |  |  |  | NO
PendingApplicantSchoolDefinedFieldValue | Non-Identifying | One To Zero or More |  |  |  |  | NO
PendingApplicantSchoolStatusHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO

PendingApplicant Check Constraints

Check Constraint Name | CheckConstraint

PendingApplicant Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.PendingApplicant | NO |  |  |
Physical (Microsoft SQL Server) dbo.AmOnlineApplicant | NO |  |  |

PendingApplicant Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Applicant_Enroll
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Admissions

PendingApplicant Data Movement Rules

Name | Type | Rule Text/Value